You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*,orders.cusnum AS d_cusnum from
LEFT JOIN orders ON .ref = orders.ref
where .' at line 1
Shell | $ | |
---|---|---|
OLIVA MINIACEA SATURATA |
6.00 | |
OBLIQUARIA REFLEXA |
15.00 | |
RANULARIA TESTUDINARIUM |
8.00 | |
CLAVUS CANALICULARIS |
6.00 | |
BARTSCHIA FUSIFORMIS |
30.00 | |
CLANCULUS MARGARITARIUS |
3.00 | |
ISCHNOCHITON ELONGATUS |
12.00 | |
GEMMULA MARTINI |
20.00 | |
PHENACOVOLVA POPPEI |
20.00 | |
SPONDYLUS NICOBARICUS CILIATUS |
15.00 | |
PTERYGIA NUCEA |
6.00 | |
MONETARIA ANNULUS |
3.00 | |
COLUMBELLA RUSTICA |
3.00 | |
CONUS CANONICUS |
8.00 | |
CERITHIUM TRAILLII |
3.00 | |
TURRITRITON TENUILIRATUM |
12.00 | |
STROMBUS FRAGILIS |
6.00 | |
STROMBUS MUTABILIS |
6.00 | |
OLIVA CONCINNA |
6.00 | |
OSILINUS LINEATUS |
3.00 | |
FUSINUS CINEREUS |
8.00 | |
CANCELLARIA LYRATA |
8.00 | |
OLIVA OLIVA STELLATA |
6.00 | |
HYDATINA PHYSIS |
4.00 | |
PINCTADA RADIATA |
20.00 | |
ACROSTERIGMA HOBBSAE |
25.00 | |
PUSIA CROCATUM |
4.00 | |
CONUS CHOLMONDELEYI |
35.00 | |
OLIVA SEMMELINKI |
6.00 | |
BARBATIA FUSCA |
6.00 | |
GEORGIA POIRIERI |
8.00 | |
CONUS LEGATUS |
12.00 | |
Total: | 333.00 |